package com.dp.pub;

import java.sql.Types;

import org.hibernate.Hibernate;
import org.hibernate.dialect.MySQLDialect;
import org.hibernate.dialect.function.StandardSQLFunction;

public class MySqlDialectEx extends org.hibernate.dialect.MySQL5InnoDBDialect{
    public MySqlDialectEx() {
        super();
        System.out.println("----------------------------------"+Hibernate.TEXT.getName());
        registerHibernateType(Types.LONGVARCHAR, Hibernate.TEXT.getName());
       // registerHibernateType(Types.LONGVARCHAR, "text");
      //  registerHibernateType(Types.LONGVARCHAR, "longtext");
         registerHibernateType(Types.DECIMAL, Hibernate.BIG_DECIMAL.getName());  
         registerFunction("group_concat", new StandardSQLFunction(  "group_concat", Hibernate.STRING));  
    }
}
